SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspOrder_INSERT
(
@customerId AS int = null,
@productId AS int = null,
@createdDate AS datetime = null,
@lastModifiedDate AS datetime = null,
@commitDate AS datetime = null,
@sendDate AS datetime = null,
@isDeleted AS bit = null,
@isCommited AS bit = null
)
AS

INSERT INTO
  [dbo].[Order]
(
  [CustomerId],
  [ProductId],
  [CreatedDate],
  [LastModifiedDate],
  [CommitDate],
  [SendDate],
  [IsDeleted],
  [IsCommited]
)
VALUES
(
  @customerId,
  @productId,
  @createdDate,
  @lastModifiedDate,
  @commitDate,
  @sendDate,
  @isDeleted,
  @isCommited
)

SELECT SCOPE_IDENTITY()


GO
